| CodIsirComment |
| EntityType | Independent |
| Logical Entity Name | CodIsirComment |
| Default Table Name | FaSysComments |
| Logical Only | NO |
| Definition | |
| Note |
| CodIsirComment Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Id |
INTEGER | NO | ||
| AwardYear | CHAR(7) | YES | ||
| Type | CHAR(10) | YES | ||
| Code | CHAR(3) | YES | ||
| Comment | VARCHAR(1000) | YES | ||
| LineCount | INTEGER | YES | ||
| MessageType | CHAR(1) | YES | ||
| RejectCode | VARCHAR(2) | YES | ||
| IsCCode | BIT | NO | ||
| IsPellSeogIneligble | BIT | NO | ||
| IsTitle4Ineligble | BIT | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
ResourceKey |
NVARCHAR(128) | YES | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO |
| CodIsirComment Keys |
| Key Name | Key Type | Keys |
| FaSysComments_Code_Type_AwardYear_FaSysCommentsID_U_N_IDX | Alternate Key | Code, Type, AwardYear, Id |
| FaSysComments_Type_N_N_IDX | Inversion Entry | Type |
| FaSysComments_AwardYear_N_N_IDX | Inversion Entry | AwardYear |
| FaSysComments_FaSysCommentsID_U_C_IDX | PrimaryKey | Id |
| FaSysComments_Type_AwardYear_N_N_IDX | Inversion Entry | Type, AwardYear |
| CodIsirComment Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| FaaProcessExceptionTypeTemplate | Non-Identifying | Zero or One to Zero or More | ResourceKey | NO | |||
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| CodIsirComment Check Constraints |
| Check Constraint Name | CheckConstraint |
| Chk_FaSysComments_AwardYear_RejectCode | ([AwardYear] = '2003-04' and ([RejectCode] = 'DE' or ([RejectCode] = '1' or ([RejectCode] = 'P' or ([RejectCode] = '16' or ([RejectCode] = 'W' or ([RejectCode] = '9' or ([RejectCode] = '17' or ([RejectCode] = '8' or ([RejectCode] = '18' or ([RejectCode] = '10' or ([RejectCode] = 'R' or ([RejectCode] = 'B' or ([RejectCode] = '11' or ([RejectCode] = '19' or ([RejectCode] = '2' or ([RejectCode] = 'A' or ([RejectCode] = 'D' or ([RejectCode] = '12' or ([RejectCode] = '5' or ([RejectCode] = '13' or ([RejectCode] = 'C' or ([RejectCode] = '14' or ([RejectCode] = 'N' or ([RejectCode] = 'E' or [RejectCode] = '15')))))))))))))))))))))))) or [AwardYear] = '2003-04' and [RejectCode] is null or [AwardYear] <> '2003-04') |